package org.jeecg.modules.inventory.mapper;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.apache.ibatis.annotations.Param;
import org.jeecg.modules.inventory.entity.BussInventory;
import org.jeecg.modules.inventory.entity.BussInventoryInoutDetails;
import org.jeecg.modules.inventory.entity.BussInventoryLedger;
import org.jeecg.modules.inventory.entity.BussInventoryLedgerDetails;
import org.jeecg.modules.inventory.vo.BussInventoryPage;

import java.util.Date;
import java.util.List;

/**
 * @Description: 库存管理
 * @Author: jeecg-boot
 * @Date:   2024-07-01
 * @Version: V1.0
 */
public interface BussInventoryLedgerMapper extends BaseMapper<BussInventoryLedger> {


    public IPage<BussInventoryLedger> myPage(Page<BussInventoryLedger> page, @Param("startTime") String startTime, @Param("endTime") String endTime,@Param("categoryCode") String categoryCode,@Param("warehouseId") String warehouseId);

    BussInventoryLedgerDetails findOpeningBalance(@Param("warehouseId") String warehouseId, @Param("materialId") String materialId, @Param("startTime") String startTime);

    List<BussInventoryLedgerDetails> findInoutDetails(@Param("warehouseId") String warehouseId, @Param("materialId") String materialId, @Param("startTime") String startTime, @Param("endTime") String endTime);
}
